#/bin/bash
hive -e "create table if not exists xm02dw.dw_cont_info(
cont_id string,
cust_type string,
cust_id string,
cust_name string,
cont_type string,
cont_status string,
exec_date string,
effe_date string,
expiry_date string,
cont_amount double,
curr_type string,
int_rate string,
penal_sate string,
repa_fq string,
inme_amount double,
repa_date string,
repa_number string,
repa_method string,
guar_info string,
colla_dp string,
loan_purpose string,
over_status string,
overd_days double,
overd_amount double,
overd_fees double,
overd_intan double,
risk_class string,
spec_reserve double,
inst_id string,
am_id string,
ie_date string,
iu_date string,
ta_credit double,
tacc_id string,
etl_time string
)
row format delimited fields terminated by ',';"
echo $?


#/bin/bash
hive -e "create table if not exists xm02dw.dw_loan_apfo(
app_id string,
cust_type string,
cust_id string,
cust_name string,
nc_id string,
cont_info double,
address string,
eb_info string,
i_revenue double,
l_amount double,
indu_class string,
s_repay string,
asset_info string,
guara_info string,
colla_dp string,
repay_plan string,
db_account string,
loan_purpose string,
e_years double,
ec_name string,
ec_id string,
ec_phone double,
app_date string,
cr_number string,
pl_records string,
email string,
inst_id string,
am_id string,
a_status string,
a_date string,
etl_time string
)
row format delimited fields terminated by ',';"
echo $?